<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
		<head>
			<!-- template designed by Marco Von Ballmoos -->
			<title>File Source for MySQLHelpService.php</title>
			<link rel="stylesheet" href="../media/stylesheet.css" />
			<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'/>
		</head>
		<body>
						<h1>Source for file MySQLHelpService.php</h1>
<p>Documentation is available at <a href="../MySQLService/_MySQLHelpService.php.html">MySQLHelpService.php</a></p>
<div class="src-code">
<div class="src-code"><ol><li><div class="src-line"><a name="a1"></a><span class="src-php">&lt;?php</span></div></li>
<li><div class="src-line"><a name="a2"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a3"></a><span class="src-key">class&nbsp;</span><a href="../MySQLService/MySQLHelpService.html">MySQLHelpService</a></div></li>
<li><div class="src-line"><a name="a4"></a><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a5"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">private&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#var$mysqli">$mysqli</a><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a6"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a7"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method__construct">__construct</a><span class="src-sym">(&nbsp;</span><span class="src-var">$host</span><span class="src-sym">,&nbsp;</span><span class="src-var">$username</span><span class="src-sym">,&nbsp;</span><span class="src-var">$password&nbsp;</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a8"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a9"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-comm">//temporary&nbsp;for&nbsp;the&nbsp;bs&nbsp;warning&nbsp;signs&nbsp;on&nbsp;live</span></div></li>
<li><div class="src-line"><a name="a10"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-comm">//&nbsp;Report&nbsp;simple&nbsp;running&nbsp;errors</span></div></li>
<li><div class="src-line"><a name="a11"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="http://www.php.net/error_reporting">error_reporting</a>&nbsp;<span class="src-sym">(&nbsp;</span><span class="src-id">E_ERROR&nbsp;</span>|&nbsp;<span class="src-id">E_USER_ERROR&nbsp;</span>|&nbsp;<span class="src-id">E_PARSE&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a12"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div></li>
<li><div class="src-line"><a name="a13"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../MySQLService/MySQLHelpService.html#var$mysqli">mysqli</a>&nbsp;=&nbsp;<span class="src-key">new&nbsp;</span><span class="src-id"><a href="../MySQLService/MySQLHelpService.html#var$mysqli">mysqli</a>&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$host</span><span class="src-sym">,&nbsp;</span><span class="src-var">$username</span><span class="src-sym">,&nbsp;</span><span class="src-var">$password&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a14"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-comm">/*&nbsp;check&nbsp;connection&nbsp;*/</span></div></li>
<li><div class="src-line"><a name="a15"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">if&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-id">mysqli_connect_errno&nbsp;</span><span class="src-sym">(</span><span class="src-sym">)&nbsp;)</span></div></li>
<li><div class="src-line"><a name="a16"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a17"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="http://www.php.net/trigger_error">trigger_error</a>&nbsp;<span class="src-sym">(&nbsp;</span><span class="src-str">'Database&nbsp;connection&nbsp;failure:&nbsp;Username/Password&nbsp;was&nbsp;incorrect.'</span><span class="src-sym">,&nbsp;</span><span class="src-id">E_USER_ERROR&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a18"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">exit&nbsp;</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a19"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}&nbsp;</span><span class="src-key">else</span></div></li>
<li><div class="src-line"><a name="a20"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a21"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../MySQLService/MySQLHelpService.html#var$mysqli">mysqli</a><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a22"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a23"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a24"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a25"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#methodgetHelpTree">getHelpTree</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a26"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a27"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$helpTree</span><span class="src-sym">[</span><span class="src-sym">]&nbsp;</span>=&nbsp;<span class="src-key">array</span><span class="src-sym">(&nbsp;</span></div></li>
<li><div class="src-line"><a name="a28"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-str">'label'&nbsp;</span>=&gt;&nbsp;<span class="src-str">'MySQL&nbsp;Help'</span><span class="src-sym">,&nbsp;</span><span class="src-str">'children'&nbsp;</span>=&gt;&nbsp;<span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../MySQLService/MySQLHelpService.html#method_getAllHelp">_getAllHelp</a>&nbsp;<span class="src-sym">(</span><span class="src-sym">)&nbsp;</span></div></li>
<li><div class="src-line"><a name="a29"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a30"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div></li>
<li><div class="src-line"><a name="a31"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><a href="http://www.php.net/json_encode">json_encode</a>&nbsp;<span class="src-sym">(&nbsp;</span><span class="src-var">$helpTree&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a32"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a33"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a34"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getAllHelp">_getAllHelp</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a35"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a36"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;</span></div></li>
<li><div class="src-line"><a name="a37"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name&nbsp;as&nbsp;category,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a38"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_topic.name&nbsp;as&nbsp;label,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a39"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_topic.description&nbsp;as&nbsp;description,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a40"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_topic.example&nbsp;as&nbsp;example</span></div></li>
<li><div class="src-line"><a name="a41"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a42"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a43"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a44"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a45"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a46"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ORDER&nbsp;BY&nbsp;category&nbsp;ASC&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a47"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div></li>
<li><div class="src-line"><a name="a48"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../MySQLService/MySQLHelpService.html#method_queryToARRAY">_queryToARRAY</a>&nbsp;<span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a49"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a50"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a51"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getDataDefinition">_getDataDefinition</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a52"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a53"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;</span></div></li>
<li><div class="src-line"><a name="a54"></a><span class="src-str">help_keyword.name&nbsp;as&nbsp;keyword,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a55"></a><span class="src-str">help_category.name&nbsp;as&nbsp;category,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a56"></a><span class="src-str">help_topic.name&nbsp;as&nbsp;topic,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a57"></a><span class="src-str">help_topic.description&nbsp;as&nbsp;description,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a58"></a><span class="src-str">help_topic.example&nbsp;as&nbsp;example</span></div></li>
<li><div class="src-line"><a name="a59"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a60"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a61"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a62"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a63"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a64"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a65"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a66"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Data&nbsp;Definition'</span></div></li>
<li><div class="src-line"><a name="a67"></a><span class="src-str">ORDER&nbsp;BY&nbsp;topic&nbsp;ASC&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a68"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a69"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a70"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a71"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getDataManipulation">_getDataManipulation</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a72"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a73"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;</span></div></li>
<li><div class="src-line"><a name="a74"></a><span class="src-str">help_keyword.name&nbsp;as&nbsp;keyword,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a75"></a><span class="src-str">help_category.name&nbsp;as&nbsp;category,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a76"></a><span class="src-str">help_topic.name&nbsp;as&nbsp;topic,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a77"></a><span class="src-str">help_topic.description&nbsp;as&nbsp;description,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a78"></a><span class="src-str">help_topic.example&nbsp;as&nbsp;example</span></div></li>
<li><div class="src-line"><a name="a79"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a80"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a81"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a82"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a83"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a84"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a85"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a86"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Data&nbsp;Manipulation'</span></div></li>
<li><div class="src-line"><a name="a87"></a><span class="src-str">ORDER&nbsp;BY&nbsp;topic&nbsp;ASC&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a88"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a89"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a90"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a91"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getTableMaintenance">_getTableMaintenance</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a92"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a93"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a94"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a95"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a96"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a97"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a98"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a99"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a100"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a101"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Table&nbsp;Maintenance'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a102"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a103"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a104"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a105"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getStoredRoutines">_getStoredRoutines</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a106"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a107"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a108"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a109"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a110"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a111"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getAdministration">_getAdministration</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a112"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a113"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;</span></div></li>
<li><div class="src-line"><a name="a114"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_keyword.name&nbsp;as&nbsp;keyword,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a115"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name&nbsp;as&nbsp;category,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a116"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_topic.name&nbsp;as&nbsp;topic,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a117"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_topic.description&nbsp;as&nbsp;description,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a118"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_topic.example&nbsp;as&nbsp;example</span></div></li>
<li><div class="src-line"><a name="a119"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a120"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a121"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a122"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a123"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a124"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a125"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a126"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Administration'</span></div></li>
<li><div class="src-line"><a name="a127"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ORDER&nbsp;BY&nbsp;topic&nbsp;ASC&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a128"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a129"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a130"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a131"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getDataTypes">_getDataTypes</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a132"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a133"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;</span></div></li>
<li><div class="src-line"><a name="a134"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECT&nbsp;</span></div></li>
<li><div class="src-line"><a name="a135"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_keyword.name&nbsp;as&nbsp;keyword,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a136"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name&nbsp;as&nbsp;category,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a137"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_topic.name&nbsp;as&nbsp;topic,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a138"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_topic.description&nbsp;as&nbsp;description,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a139"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_topic.example&nbsp;as&nbsp;example</span></div></li>
<li><div class="src-line"><a name="a140"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a141"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a142"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a143"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a144"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a145"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a146"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a147"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Data&nbsp;Types'</span></div></li>
<li><div class="src-line"><a name="a148"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ORDER&nbsp;BY&nbsp;topic&nbsp;ASC&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a149"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a150"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a151"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a152"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getAccountManagement">_getAccountManagement</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a153"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a154"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;</span></div></li>
<li><div class="src-line"><a name="a155"></a><span class="src-str">help_keyword.name&nbsp;as&nbsp;keyword,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a156"></a><span class="src-str">help_category.name&nbsp;as&nbsp;category,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a157"></a><span class="src-str">help_topic.name&nbsp;as&nbsp;topic,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a158"></a><span class="src-str">help_topic.description&nbsp;as&nbsp;description,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a159"></a><span class="src-str">help_topic.example&nbsp;as&nbsp;example</span></div></li>
<li><div class="src-line"><a name="a160"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a161"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a162"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a163"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a164"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a165"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a166"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a167"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Account&nbsp;Management'</span></div></li>
<li><div class="src-line"><a name="a168"></a><span class="src-str">ORDER&nbsp;BY&nbsp;topic&nbsp;ASC&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a169"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a170"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a171"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a172"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getStringFunctions">_getStringFunctions</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a173"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a174"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;</span></div></li>
<li><div class="src-line"><a name="a175"></a><span class="src-str">help_keyword.name&nbsp;as&nbsp;keyword,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a176"></a><span class="src-str">help_category.name&nbsp;as&nbsp;category,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a177"></a><span class="src-str">help_topic.name&nbsp;as&nbsp;topic,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a178"></a><span class="src-str">help_topic.description&nbsp;as&nbsp;description,&nbsp;</span></div></li>
<li><div class="src-line"><a name="a179"></a><span class="src-str">help_topic.example&nbsp;as&nbsp;example</span></div></li>
<li><div class="src-line"><a name="a180"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a181"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a182"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a183"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a184"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a185"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a186"></a><span class="src-str">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a187"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'String&nbsp;Functions'</span></div></li>
<li><div class="src-line"><a name="a188"></a><span class="src-str">ORDER&nbsp;BY&nbsp;topic&nbsp;ASC&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a189"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a190"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a191"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a192"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getControlFlow">_getControlFlow</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a193"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a194"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;&nbsp;SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a195"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a196"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a197"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a198"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a199"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a200"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a201"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a202"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Control&nbsp;flow&nbsp;functions'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a203"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a204"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a205"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a206"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_gettTransactions">_gettTransactions</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a207"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a208"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a209"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a210"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a211"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a212"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a213"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a214"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a215"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a216"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Transactions'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a217"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a218"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a219"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a220"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getFunctions">_getFunctions</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a221"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a222"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a223"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a224"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a225"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a226"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a227"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a228"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a229"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a230"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Functions'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a231"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a232"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a233"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a234"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getWKT">_getWKT</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a235"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a236"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a237"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a238"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a239"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a240"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a241"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a242"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a243"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a244"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'WKB'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a245"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a246"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a247"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a248"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getWKB">_getWKB</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a249"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a250"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a251"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a252"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a253"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a254"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a255"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a256"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a257"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a258"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'WKB'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a259"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a260"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a261"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a262"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getNumericFunctions">_getNumericFunctions</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a263"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a264"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;'SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a265"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a266"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a267"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a268"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a269"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a270"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a271"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a272"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Numeric&nbsp;Functions'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a273"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a274"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a275"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a276"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getLanguageStructure">_getLanguageStructure</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a277"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a278"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a279"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a280"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a281"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a282"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a283"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a284"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a285"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a286"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Language&nbsp;Structure'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a287"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a288"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a289"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a290"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getComparison">_getComparison</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a291"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a292"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a293"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a294"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a295"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a296"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a297"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a298"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a299"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a300"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Comparison&nbsp;operators'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a301"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a302"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a303"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a304"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getDateTime">_getDateTime</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a305"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a306"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a307"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a308"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a309"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a310"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a311"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a312"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a313"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a314"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Date&nbsp;and&nbsp;Time&nbsp;Functions'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a315"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a316"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a317"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a318"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getLogicalOpperators">_getLogicalOpperators</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a319"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a320"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a321"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a322"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a323"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a324"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a325"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a326"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a327"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a328"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Logical&nbsp;operators'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a329"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a330"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a331"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a332"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getEncryptionFunctions">_getEncryptionFunctions</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a333"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a334"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a335"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a336"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a337"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a338"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a339"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a340"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a341"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a342"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Encryption&nbsp;Functions'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a343"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a344"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a345"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a346"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getGeographicFeatures">_getGeographicFeatures</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a347"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a348"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>=&nbsp;<span class="src-str">&quot;SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a349"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a350"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a351"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a352"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a353"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a354"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a355"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a356"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Geographic&nbsp;Features'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a357"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a358"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a359"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a360"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">public&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_getTriggers">_getTriggers</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a361"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a362"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$sql&nbsp;</span>-&nbsp;<span class="src-str">&quot;SELECT&nbsp;help_keyword.name,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;help_category.name,&nbsp;help_topic.name,&nbsp;help_topic.description,&nbsp;help_topic.example</span></div></li>
<li><div class="src-line"><a name="a363"></a><span class="src-str">FROM&nbsp;mysql.help_relation&nbsp;</span></div></li>
<li><div class="src-line"><a name="a364"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_keyword&nbsp;</span></div></li>
<li><div class="src-line"><a name="a365"></a><span class="src-str">ON&nbsp;help_relation.help_keyword_id&nbsp;=&nbsp;help_keyword.help_keyword_id</span></div></li>
<li><div class="src-line"><a name="a366"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_topic&nbsp;</span></div></li>
<li><div class="src-line"><a name="a367"></a><span class="src-str">ON&nbsp;help_relation.help_topic_id&nbsp;=&nbsp;help_topic.help_topic_id</span></div></li>
<li><div class="src-line"><a name="a368"></a><span class="src-str">INNER&nbsp;JOIN&nbsp;mysql.help_category&nbsp;</span></div></li>
<li><div class="src-line"><a name="a369"></a><span class="src-str">ON&nbsp;help_category.help_category_id&nbsp;=&nbsp;help_topic.help_category_id</span></div></li>
<li><div class="src-line"><a name="a370"></a><span class="src-str">WHERE&nbsp;help_category.name&nbsp;=&nbsp;'Triggers'&quot;</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a371"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><span class="src-id">_queryToArray&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a372"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a373"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a374"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-comm">/*&nbsp;********************************************************************</span></div></li>
<li><div class="src-line"><a name="a375"></a><span class="src-comm">*&nbsp;********************************************************************</span></div></li>
<li><div class="src-line"><a name="a376"></a><span class="src-comm">*&nbsp;</span></div></li>
<li><div class="src-line"><a name="a377"></a><span class="src-comm">*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8.&nbsp;RESULT&nbsp;HANDLERS</span></div></li>
<li><div class="src-line"><a name="a378"></a><span class="src-comm">*&nbsp;</span></div></li>
<li><div class="src-line"><a name="a379"></a><span class="src-comm">*&nbsp;********************************************************************</span></div></li>
<li><div class="src-line"><a name="a380"></a><span class="src-comm">*&nbsp;********************************************************************/</span></div></li>
<li><div class="src-line"><a name="a381"></a>&nbsp;&nbsp;&nbsp;&nbsp;</div></li>
<li><div class="src-line"><a name="a382"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a383"></a><span class="src-doc">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;I&nbsp;execute&nbsp;a&nbsp;query&nbsp;and&nbsp;return&nbsp;the&nbsp;results&nbsp;as&nbsp;json.</span></div></li>
<li><div class="src-line"><a name="a384"></a><span class="src-doc">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*</span></div></li>
<li><div class="src-line"><a name="a385"></a><span class="src-doc">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;</span><span class="src-doc-coretag">@param&nbsp;</span><span class="src-doc-type">[string]&nbsp;</span><span class="src-doc-var">$sql&nbsp;</span><span class="src-doc">the&nbsp;query&nbsp;to&nbsp;be&nbsp;executed</span></div></li>
<li><div class="src-line"><a name="a386"></a><span class="src-doc">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;</span><span class="src-doc-coretag">@return&nbsp;</span><span class="src-doc-type">[json]&nbsp;</span><span class="src-doc">the&nbsp;result&nbsp;in&nbsp;json</span></div></li>
<li><div class="src-line"><a name="a387"></a><span class="src-doc">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</span></div></li>
<li><div class="src-line"><a name="a388"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">private&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_queryToJSON">_queryToJSON</a><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a389"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a390"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$result&nbsp;</span>=&nbsp;<span class="src-id">mysqli_query&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../MySQLService/MySQLHelpService.html#var$mysqli">mysqli</a><span class="src-sym">,&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a391"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div></li>
<li><div class="src-line"><a name="a392"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">while&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$row&nbsp;</span>=&nbsp;<span class="src-id">mysqli_fetch_assoc&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$result&nbsp;</span><span class="src-sym">)&nbsp;)</span></div></li>
<li><div class="src-line"><a name="a393"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a394"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$array</span><span class="src-sym">[</span><span class="src-sym">]&nbsp;</span>=&nbsp;<span class="src-var">$row</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a395"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a396"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><a href="http://www.php.net/json_encode">json_encode</a>&nbsp;<span class="src-sym">(&nbsp;</span><span class="src-var">$array&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a397"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a398"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a399"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a400"></a><span class="src-doc">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;I&nbsp;execute&nbsp;a&nbsp;query&nbsp;and&nbsp;return&nbsp;the&nbsp;result&nbsp;as&nbsp;an&nbsp;array.</span></div></li>
<li><div class="src-line"><a name="a401"></a><span class="src-doc">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*</span></div></li>
<li><div class="src-line"><a name="a402"></a><span class="src-doc">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;</span><span class="src-doc-coretag">@param&nbsp;</span><span class="src-doc-type">[string]&nbsp;</span><span class="src-doc-var">$sql&nbsp;</span><span class="src-doc">the&nbsp;query&nbsp;to&nbsp;be&nbsp;executed</span></div></li>
<li><div class="src-line"><a name="a403"></a><span class="src-doc">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*&nbsp;</span><span class="src-doc-coretag">@return&nbsp;</span><span class="src-doc-type">[array]&nbsp;</span><span class="src-doc">the&nbsp;result&nbsp;array</span></div></li>
<li><div class="src-line"><a name="a404"></a><span class="src-doc">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/</span></div></li>
<li><div class="src-line"><a name="a405"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">private&nbsp;</span><span class="src-key">function&nbsp;</span><a href="../MySQLService/MySQLHelpService.html#method_queryToARRAY">_queryToARRAY</a><span class="src-sym">(&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a406"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a407"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$query&nbsp;</span>=&nbsp;<span class="src-id">mysqli_query&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../MySQLService/MySQLHelpService.html#var$mysqli">mysqli</a><span class="src-sym">,&nbsp;</span><span class="src-var">$sql&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a408"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$array&nbsp;</span>=&nbsp;<span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a409"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div></li>
<li><div class="src-line"><a name="a410"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">while&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$row&nbsp;</span>=&nbsp;<span class="src-id">mysqli_fetch_assoc&nbsp;</span><span class="src-sym">(&nbsp;</span><span class="src-var">$query&nbsp;</span><span class="src-sym">)&nbsp;)</span></div></li>
<li><div class="src-line"><a name="a411"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a412"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$array</span><span class="src-sym">[</span><span class="src-sym">]&nbsp;</span>=&nbsp;<span class="src-var">$row</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a413"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a414"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div></li>
<li><div class="src-line"><a name="a415"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-key">return&nbsp;</span><span class="src-var">$array</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a416"></a>&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a417"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a418"></a><span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a419"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a420"></a><span class="src-comm">//testing</span></div></li>
<li><div class="src-line"><a name="a421"></a><span class="src-comm">//$help&nbsp;=&nbsp;new&nbsp;MySQLHelpService(&nbsp;'localhost',&nbsp;'root',&nbsp;'fred'&nbsp;);</span></div></li>
<li><div class="src-line"><a name="a422"></a><span class="src-comm">//print_r(&nbsp;$help-&gt;getHelpTree()&nbsp;);</span></div></li>
<li><div class="src-line"><a name="a423"></a>&nbsp;</div></li>
<li><div class="src-line"><a name="a424"></a><span class="src-php">?&gt;</span></div></li>
</ol></div>
</div>
	<p class="notes" id="credit">
		Documentation generated on Fri, 20 Feb 2009 22:08:34 -0800 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.4.1</a>
	</p>
	</body>
</html>